MRR
-- November MRR by tenant
SELECT
SUM(amount_in_usd_cents) / 100 AS MRR,
count(*),
MONTH(payment_date),
tenant_id,
name
FROM
payments
JOIN tenants ON tenants.id = payments.tenant_id
WHERE
sandbox = 0
AND status = 'approved'
AND plan_type = 'recurring'
AND YEAR(payment_date) = '2020'
AND Month(payment_date) = '11'
-- AND payment_date between '2020-11-01' and '2020-12-01'
GROUP BY
tenant_id
ORDER BY
MRR DESC;
-- Platform wide MRR
SELECT
SUM(amount_in_usd_cents) / 100 AS MRR,
count(*),
MONTH(payment_date) as payment_date_month
FROM
payments
WHERE
sandbox = 0
AND status = 'approved'
AND plan_type = 'recurring'
AND YEAR(payment_date) = '2020'
-- AND Month(payment_date) = '11'
-- and tenant_id = 1752
-- AND payment_date between '2020-11-01' and '2020-12-01'
GROUP BY
payment_date_month
ORDER BY
payment_date_month DESC;